credit

Dataset statistics

Number of variables	19
Number of observations	100514
Missing cells	105653
Missing cells (%)	5.5%
Duplicate rows	10216
Duplicate rows (%)	10.2%
Total size in memory	14.6 MiB
Average record size in memory	152.0 B

Variable types

Categorical	7
Numeric	12

Alerts

Dataset has 10216 (10.2%) duplicate rows	Duplicates
`Loan ID` has a high cardinality: 81999 distinct values	High cardinality
`Customer ID` has a high cardinality: 81999 distinct values	High cardinality
`Annual Income` is highly overall correlated with `Monthly Debt`	High correlation
`Monthly Debt` is highly overall correlated with `Annual Income` and 1 other fields	High correlation
`Number of Credit Problems` is highly overall correlated with `Bankruptcies`	High correlation
`Current Credit Balance` is highly overall correlated with `Monthly Debt` and 1 other fields	High correlation
`Maximum Open Credit` is highly overall correlated with `Current Credit Balance`	High correlation
`Bankruptcies` is highly overall correlated with `Number of Credit Problems`	High correlation
`Purpose` is highly imbalanced (66.1%)	Imbalance
`Credit Score` has 19668 (19.6%) missing values	Missing
`Annual Income` has 19668 (19.6%) missing values	Missing
`Years in current job` has 4736 (4.7%) missing values	Missing
`Months since last delinquent` has 53655 (53.4%) missing values	Missing
`Annual Income` is highly skewed (γ1 = 46.88869873)	Skewed
`Maximum Open Credit` is highly skewed (γ1 = 132.6388749)	Skewed
`Loan ID` is uniformly distributed	Uniform
`Customer ID` is uniformly distributed	Uniform
`Number of Credit Problems` has 86035 (85.6%) zeros	Zeros
`Bankruptcies` has 88774 (88.3%) zeros	Zeros
`Tax Liens` has 98062 (97.6%) zeros	Zeros

Reproduction

Analysis started	2023-08-29 23:41:16.963545
Analysis finished	2023-08-29 23:42:21.677248
Duration	1 minute and 4.71 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Loan ID
Categorical

HIGH CARDINALITY UNIFORM

Distinct	81999
Distinct (%)	82.0%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

ede97bab-caf2-4b16-9353-efc166df4c50	2
c5affebf-2290-454b-8514-82923b120bce	2
1e5509c6-96b2-4f80-930a-4afa804a7672	2
2e6c0462-5c05-424b-b31b-6588cbca7d52	2
427ba12e-9f21-4e69-affe-7f1d95cb1587	2
Other values (81994)	99990

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	3600000
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63998 ?
Unique (%)	64.0%

Sample

1st row	14dd8831-6af5-400b-83ec-68e61888a048
2nd row	4771cc26-131a-45db-b5aa-537ea4ba5342
3rd row	4eed4e6a-aa2f-4c91-8651-ce984ee8fb26
4th row	77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a
5th row	d4062e70-befa-4995-8643-a0de73938182

Common Values

Value	Count	Frequency (%)
ede97bab-caf2-4b16-9353-efc166df4c50	2	< 0.1%
c5affebf-2290-454b-8514-82923b120bce	2	< 0.1%
1e5509c6-96b2-4f80-930a-4afa804a7672	2	< 0.1%
2e6c0462-5c05-424b-b31b-6588cbca7d52	2	< 0.1%
427ba12e-9f21-4e69-affe-7f1d95cb1587	2	< 0.1%
c2e22a73-7668-4c93-8d18-2f1fe6348c27	2	< 0.1%
afee91ac-2aa0-4731-aad1-bd07e28d6943	2	< 0.1%
e9f492e7-0122-4523-bb85-eca6658fa5cf	2	< 0.1%
752d658a-55d2-431d-9953-d9f275e87e9f	2	< 0.1%
cf24dd94-3966-4cb9-a723-7e16559ab73c	2	< 0.1%
Other values (81989)	99980	99.5%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ede97bab-caf2-4b16-9353-efc166df4c50	2	< 0.1%
e7d6cc4c-012c-4221-887d-89f7ec2c32af	2	< 0.1%
13e52871-68a6-4cf1-8f0a-13a4c6cc44a3	2	< 0.1%
d75e7609-0432-451e-9d6f-eb064d94db44	2	< 0.1%
2d26a0f0-cf0d-45f2-85c0-fb43e7c81fd6	2	< 0.1%
4b73ff1d-1585-4936-b60a-ba86527fd69c	2	< 0.1%
67a34840-e0d3-41a1-b94e-395600300989	2	< 0.1%
cfa6ef12-53b2-40c2-a213-1baf3ec664a7	2	< 0.1%
b17d4708-8f51-4297-989f-e1c11563919d	2	< 0.1%
4691d4a1-993b-4163-94a6-1dfff439b0ab	2	< 0.1%
Other values (81989)	99980	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	400000	11.1%
4	287551	8.0%
a	212644	5.9%
9	212346	5.9%
b	211946	5.9%
8	211864	5.9%
0	188172	5.2%
2	188148	5.2%
c	188078	5.2%
7	187813	5.2%
Other values (7)	1311438	36.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2025282	56.3%
Lowercase Letter	1174718	32.6%
Dash Punctuation	400000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	287551	14.2%
9	212346	10.5%
8	211864	10.5%
0	188172	9.3%
2	188148	9.3%
7	187813	9.3%
1	187606	9.3%
5	187480	9.3%
3	187225	9.2%
6	187077	9.2%

Lowercase Letter

Value	Count	Frequency (%)
a	212644	18.1%
b	211946	18.0%
c	188078	16.0%
e	187476	16.0%
d	187374	16.0%
f	187200	15.9%

Dash Punctuation

Value	Count	Frequency (%)
-	400000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2425282	67.4%
Latin	1174718	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	400000	16.5%
4	287551	11.9%
9	212346	8.8%
8	211864	8.7%
0	188172	7.8%
2	188148	7.8%
7	187813	7.7%
1	187606	7.7%
5	187480	7.7%
3	187225	7.7%

Latin

Value	Count	Frequency (%)
a	212644	18.1%
b	211946	18.0%
c	188078	16.0%
e	187476	16.0%
d	187374	16.0%
f	187200	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3600000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	400000	11.1%
4	287551	8.0%
a	212644	5.9%
9	212346	5.9%
b	211946	5.9%
8	211864	5.9%
0	188172	5.2%
2	188148	5.2%
c	188078	5.2%
7	187813	5.2%
Other values (7)	1311438	36.4%

Customer ID
Categorical

HIGH CARDINALITY UNIFORM

Distinct	81999
Distinct (%)	82.0%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

9ef4f39f-b848-4227-803b-89fb1188f7d5	2
491764d1-3c6e-4c63-8b82-e03f75b36fd1	2
94a7d438-07d8-4ea7-9f79-4b4f88218a8b	2
02a9852c-ae76-486c-9397-11178993769f	2
02a6ae13-b430-4b80-83f3-cf087e2c61d9	2
Other values (81994)	99990

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	3600000
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63998 ?
Unique (%)	64.0%

Sample

1st row	981165ec-3274-42f5-a3b4-d104041a9ca9
2nd row	2de017a3-2e01-49cb-a581-08169e83be29
3rd row	5efb2b2b-bf11-4dfd-a572-3761a2694725
4th row	e777faab-98ae-45af-9a86-7ce5b33b1011
5th row	81536ad9-5ccf-4eb8-befb-47a4d608658e

Common Values

Value	Count	Frequency (%)
9ef4f39f-b848-4227-803b-89fb1188f7d5	2	< 0.1%
491764d1-3c6e-4c63-8b82-e03f75b36fd1	2	< 0.1%
94a7d438-07d8-4ea7-9f79-4b4f88218a8b	2	< 0.1%
02a9852c-ae76-486c-9397-11178993769f	2	< 0.1%
02a6ae13-b430-4b80-83f3-cf087e2c61d9	2	< 0.1%
cea9784f-9337-43fe-82c9-a952d95ed645	2	< 0.1%
2396973d-1e39-4ce8-b1a6-8b30139d1024	2	< 0.1%
81483803-71b4-406f-90f2-44c433434e93	2	< 0.1%
aa0a2649-6ccf-43da-92f2-2cfdf532bb66	2	< 0.1%
4bf54b6f-e8a2-4d0e-aee2-3b3d98c09a34	2	< 0.1%
Other values (81989)	99980	99.5%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9ef4f39f-b848-4227-803b-89fb1188f7d5	2	< 0.1%
56dd466b-e6d7-4c85-8c0c-68f852baa539	2	< 0.1%
cfff63a5-50de-438a-8565-6269a77bf751	2	< 0.1%
bc56e2c1-7abc-41ef-83b7-4d23e5f7712d	2	< 0.1%
0dbcc7e3-689d-4a60-b009-6e4ef2c9c4d9	2	< 0.1%
418617e7-ccee-4269-948d-067fbbdea1a0	2	< 0.1%
3006517f-2af0-439c-8400-718fa53ca1b6	2	< 0.1%
1c10b8f0-fc62-426a-a081-ac6b07c10901	2	< 0.1%
7e30498f-0593-4e71-99ed-5fd7d06ea8a2	2	< 0.1%
47c7ac5e-bb4b-4033-ad05-08bea24e69b7	2	< 0.1%
Other values (81989)	99980	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	400000	11.1%
4	287889	8.0%
a	212705	5.9%
8	212170	5.9%
b	211850	5.9%
9	211791	5.9%
c	188049	5.2%
e	188024	5.2%
7	187963	5.2%
5	187790	5.2%
Other values (7)	1311769	36.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2024943	56.2%
Lowercase Letter	1175057	32.6%
Dash Punctuation	400000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	287889	14.2%
8	212170	10.5%
9	211791	10.5%
7	187963	9.3%
5	187790	9.3%
6	187624	9.3%
3	187601	9.3%
1	187434	9.3%
0	187400	9.3%
2	187281	9.2%

Lowercase Letter

Value	Count	Frequency (%)
a	212705	18.1%
b	211850	18.0%
c	188049	16.0%
e	188024	16.0%
d	187287	15.9%
f	187142	15.9%

Dash Punctuation

Value	Count	Frequency (%)
-	400000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2424943	67.4%
Latin	1175057	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	400000	16.5%
4	287889	11.9%
8	212170	8.7%
9	211791	8.7%
7	187963	7.8%
5	187790	7.7%
6	187624	7.7%
3	187601	7.7%
1	187434	7.7%
0	187400	7.7%

Latin

Value	Count	Frequency (%)
a	212705	18.1%
b	211850	18.0%
c	188049	16.0%
e	188024	16.0%
d	187287	15.9%
f	187142	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3600000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	400000	11.1%
4	287889	8.0%
a	212705	5.9%
8	212170	5.9%
b	211850	5.9%
9	211791	5.9%
c	188049	5.2%
e	188024	5.2%
7	187963	5.2%
5	187790	5.2%
Other values (7)	1311769	36.4%

Loan Status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

Fully Paid	77361
Charged Off	22639

Length

Max length	11
Median length	10
Mean length	10.22639
Min length	10

Characters and Unicode

Total characters	1022639
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Fully Paid
3rd row	Fully Paid
4th row	Fully Paid
5th row	Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	77361	77.0%
Charged Off	22639	22.5%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fully	77361	38.7%
paid	77361	38.7%
charged	22639	11.3%
off	22639	11.3%

Most occurring characters

Value	Count	Frequency (%)
l	154722	15.1%
	100000	9.8%
a	100000	9.8%
d	100000	9.8%
F	77361	7.6%
u	77361	7.6%
y	77361	7.6%
P	77361	7.6%
i	77361	7.6%
f	45278	4.4%
Other values (6)	135834	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	722639	70.7%
Uppercase Letter	200000	19.6%
Space Separator	100000	9.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	154722	21.4%
a	100000	13.8%
d	100000	13.8%
u	77361	10.7%
y	77361	10.7%
i	77361	10.7%
f	45278	6.3%
h	22639	3.1%
r	22639	3.1%
g	22639	3.1%

Uppercase Letter

Value	Count	Frequency (%)
F	77361	38.7%
P	77361	38.7%
C	22639	11.3%
O	22639	11.3%

Space Separator

Value	Count	Frequency (%)
	100000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	922639	90.2%
Common	100000	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	154722	16.8%
a	100000	10.8%
d	100000	10.8%
F	77361	8.4%
u	77361	8.4%
y	77361	8.4%
P	77361	8.4%
i	77361	8.4%
f	45278	4.9%
C	22639	2.5%
Other values (5)	113195	12.3%

Common

Value	Count	Frequency (%)
	100000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1022639	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	154722	15.1%
	100000	9.8%
a	100000	9.8%
d	100000	9.8%
F	77361	7.6%
u	77361	7.6%
y	77361	7.6%
P	77361	7.6%
i	77361	7.6%
f	45278	4.4%
Other values (6)	135834	13.3%

Current Loan Amount
Real number (ℝ)

Distinct	22004
Distinct (%)	22.0%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	11760447

Minimum	10802
Maximum	99999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	10802
5-th percentile	76054
Q1	179652
median	312246
Q3	524942
95-th percentile	99999999
Maximum	99999999
Range	99989197
Interquartile range (IQR)	345290

Descriptive statistics

Standard deviation	31783943
Coefficient of variation (CV)	2.7026134
Kurtosis	3.8373662
Mean	11760447
Median Absolute Deviation (MAD)	147664
Skewness	2.4159866
Sum	1.1760447 × 10¹²
Variance	1.010219 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99999999	11484	11.4%
216194	27	< 0.1%
223652	27	< 0.1%
223102	27	< 0.1%
223322	27	< 0.1%
108966	26	< 0.1%
222596	26	< 0.1%
214962	25	< 0.1%
216810	25	< 0.1%
179828	25	< 0.1%
Other values (21994)	88281	87.8%
(Missing)	514	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10802	1	< 0.1%
11242	1	< 0.1%
15422	2	< 0.1%
21098	1	< 0.1%
21450	3	< 0.1%
21472	9	< 0.1%
21494	3	< 0.1%
21516	6	< 0.1%
21538	7	< 0.1%
21560	4	< 0.1%

Value	Count	Frequency (%)
99999999	11484	11.4%
789250	3	< 0.1%
789184	6	< 0.1%
789096	16	< 0.1%
789030	9	< 0.1%
788942	9	< 0.1%
788876	4	< 0.1%
788788	5	< 0.1%
788722	2	< 0.1%
788634	8	< 0.1%

Term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

Short Term	72208
Long Term	27792

Length

Max length	10
Median length	10
Mean length	9.72208
Min length	9

Characters and Unicode

Total characters	972208
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Short Term
2nd row	Short Term
3rd row	Short Term
4th row	Long Term
5th row	Short Term

Common Values

Value	Count	Frequency (%)
Short Term	72208	71.8%
Long Term	27792	27.6%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
term	100000	50.0%
short	72208	36.1%
long	27792	13.9%

Most occurring characters

Value	Count	Frequency (%)
r	172208	17.7%
o	100000	10.3%
	100000	10.3%
T	100000	10.3%
e	100000	10.3%
m	100000	10.3%
S	72208	7.4%
h	72208	7.4%
t	72208	7.4%
L	27792	2.9%
Other values (2)	55584	5.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	672208	69.1%
Uppercase Letter	200000	20.6%
Space Separator	100000	10.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	172208	25.6%
o	100000	14.9%
e	100000	14.9%
m	100000	14.9%
h	72208	10.7%
t	72208	10.7%
n	27792	4.1%
g	27792	4.1%

Uppercase Letter

Value	Count	Frequency (%)
T	100000	50.0%
S	72208	36.1%
L	27792	13.9%

Space Separator

Value	Count	Frequency (%)
	100000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	872208	89.7%
Common	100000	10.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	172208	19.7%
o	100000	11.5%
T	100000	11.5%
e	100000	11.5%
m	100000	11.5%
S	72208	8.3%
h	72208	8.3%
t	72208	8.3%
L	27792	3.2%
n	27792	3.2%

Common

Value	Count	Frequency (%)
	100000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	972208	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	172208	17.7%
o	100000	10.3%
	100000	10.3%
T	100000	10.3%
e	100000	10.3%
m	100000	10.3%
S	72208	7.4%
h	72208	7.4%
t	72208	7.4%
L	27792	2.9%
Other values (2)	55584	5.7%

Credit Score
Real number (ℝ)

Distinct	324
Distinct (%)	0.4%
Missing	19668
Missing (%)	19.6%
Infinite	0
Infinite (%)	0.0%
Mean	1076.4561

Minimum	585
Maximum	7510
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	585
5-th percentile	661
Q1	705
median	724
Q3	741
95-th percentile	6690
Maximum	7510
Range	6925
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	1475.4038
Coefficient of variation (CV)	1.3706121
Kurtosis	12.971832
Mean	1076.4561
Median Absolute Deviation (MAD)	17
Skewness	3.8632253
Sum	87027169
Variance	2176816.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
747	1825	1.8%
740	1746	1.7%
746	1742	1.7%
741	1732	1.7%
742	1723	1.7%
739	1624	1.6%
745	1612	1.6%
748	1598	1.6%
743	1555	1.5%
725	1548	1.5%
Other values (314)	64141	63.8%
(Missing)	19668	19.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
585	12	< 0.1%
586	7	< 0.1%
587	11	< 0.1%
588	20	< 0.1%
589	6	< 0.1%
590	8	< 0.1%
591	9	< 0.1%
592	4	< 0.1%
593	7	< 0.1%
594	10	< 0.1%

Value	Count	Frequency (%)
7510	9	< 0.1%
7500	24	< 0.1%
7490	23	< 0.1%
7480	43	< 0.1%
7470	51	0.1%
7460	76	0.1%
7450	55	0.1%
7440	58	0.1%
7430	70	0.1%
7420	84	0.1%

Annual Income
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	36174
Distinct (%)	44.7%
Missing	19668
Missing (%)	19.6%
Infinite	0
Infinite (%)	0.0%
Mean	1378276.6

Minimum	76627
Maximum	1.6555739 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	76627
5-th percentile	519863.75
Q1	848844
median	1174162
Q3	1650663
95-th percentile	2810579.8
Maximum	1.6555739 × 10⁸
Range	1.6548077 × 10⁸
Interquartile range (IQR)	801819

Descriptive statistics

Standard deviation	1081360.2
Coefficient of variation (CV)	0.78457418
Kurtosis	6624.1677
Mean	1378276.6
Median Absolute Deviation (MAD)	380703
Skewness	46.888699
Sum	1.1142815 × 10¹¹
Variance	1.1693399 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1162572	22	< 0.1%
973370	19	< 0.1%
969475	18	< 0.1%
1140000	18	< 0.1%
1143762	17	< 0.1%
949905	17	< 0.1%
1112640	17	< 0.1%
953230	17	< 0.1%
1320291	17	< 0.1%
1166220	17	< 0.1%
Other values (36164)	80667	80.3%
(Missing)	19668	19.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
76627	1	< 0.1%
81092	1	< 0.1%
94867	1	< 0.1%
97033	1	< 0.1%
106533	1	< 0.1%
111245	2	< 0.1%
130150	1	< 0.1%
134881	2	< 0.1%
135071	2	< 0.1%
144267	2	< 0.1%

Value	Count	Frequency (%)
165557393	1	< 0.1%
36475440	1	< 0.1%
30838995	1	< 0.1%
28095300	1	< 0.1%
24161540	1	< 0.1%
23980375	1	< 0.1%
22448880	2	< 0.1%
19019000	1	< 0.1%
18768200	2	< 0.1%
18743937	1	< 0.1%

Years in current job
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	4736
Missing (%)	4.7%
Memory size	785.4 KiB

10+ years	31121
2 years	9134
3 years	8169
< 1 year	8164
5 years	6787
Other values (6)	32403

Length

Max length	9
Median length	7
Mean length	7.6676481
Min length	6

Characters and Unicode

Total characters	734392
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	8 years
2nd row	10+ years
3rd row	8 years
4th row	3 years
5th row	5 years

Common Values

Value	Count	Frequency (%)
10+ years	31121	31.0%
2 years	9134	9.1%
3 years	8169	8.1%
< 1 year	8164	8.1%
5 years	6787	6.8%
1 year	6460	6.4%
4 years	6143	6.1%
6 years	5686	5.7%
7 years	5577	5.5%
8 years	4582	4.6%
(Missing)	4736	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	81154	40.6%
10	31121	15.6%
1	14624	7.3%
year	14624	7.3%
2	9134	4.6%
3	8169	4.1%
	8164	4.1%
5	6787	3.4%
4	6143	3.1%
6	5686	2.8%
Other values (3)	14114	7.1%

Most occurring characters

Value	Count	Frequency (%)
	103942	14.2%
y	95778	13.0%
e	95778	13.0%
a	95778	13.0%
r	95778	13.0%
s	81154	11.1%
1	45745	6.2%
0	31121	4.2%
+	31121	4.2%
2	9134	1.2%
Other values (8)	49063	6.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	464266	63.2%
Decimal Number	126899	17.3%
Space Separator	103942	14.2%
Math Symbol	39285	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	45745	36.0%
0	31121	24.5%
2	9134	7.2%
3	8169	6.4%
5	6787	5.3%
4	6143	4.8%
6	5686	4.5%
7	5577	4.4%
8	4582	3.6%
9	3955	3.1%

Lowercase Letter

Value	Count	Frequency (%)
y	95778	20.6%
e	95778	20.6%
a	95778	20.6%
r	95778	20.6%
s	81154	17.5%

Math Symbol

Value	Count	Frequency (%)
+	31121	79.2%
<	8164	20.8%

Space Separator

Value	Count	Frequency (%)
	103942	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	464266	63.2%
Common	270126	36.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
	103942	38.5%
1	45745	16.9%
0	31121	11.5%
+	31121	11.5%
2	9134	3.4%
3	8169	3.0%
<	8164	3.0%
5	6787	2.5%
4	6143	2.3%
6	5686	2.1%
Other values (3)	14114	5.2%

Latin

Value	Count	Frequency (%)
y	95778	20.6%
e	95778	20.6%
a	95778	20.6%
r	95778	20.6%
s	81154	17.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	103942	14.2%
y	95778	13.0%
e	95778	13.0%
a	95778	13.0%
r	95778	13.0%
s	81154	11.1%
1	45745	6.2%
0	31121	4.2%
+	31121	4.2%
2	9134	1.2%
Other values (8)	49063	6.7%

Home Ownership
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

Home Mortgage	48410
Rent	42194
Own Home	9182
HaveMortgage	214

Length

Max length	13
Median length	12
Mean length	8.7413
Min length	4

Characters and Unicode

Total characters	874130
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Home Mortgage
2nd row	Home Mortgage
3rd row	Own Home
4th row	Own Home
5th row	Rent

Common Values

Value	Count	Frequency (%)
Home Mortgage	48410	48.2%
Rent	42194	42.0%
Own Home	9182	9.1%
HaveMortgage	214	0.2%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
home	57592	36.5%
mortgage	48410	30.7%
rent	42194	26.8%
own	9182	5.8%
havemortgage	214	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	148624	17.0%
o	106216	12.2%
g	97248	11.1%
t	90818	10.4%
H	57806	6.6%
m	57592	6.6%
	57592	6.6%
n	51376	5.9%
a	48838	5.6%
M	48624	5.6%
Other values (5)	109396	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	658732	75.4%
Uppercase Letter	157806	18.1%
Space Separator	57592	6.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	148624	22.6%
o	106216	16.1%
g	97248	14.8%
t	90818	13.8%
m	57592	8.7%
n	51376	7.8%
a	48838	7.4%
r	48624	7.4%
w	9182	1.4%
v	214	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
H	57806	36.6%
M	48624	30.8%
R	42194	26.7%
O	9182	5.8%

Space Separator

Value	Count	Frequency (%)
	57592	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	816538	93.4%
Common	57592	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	148624	18.2%
o	106216	13.0%
g	97248	11.9%
t	90818	11.1%
H	57806	7.1%
m	57592	7.1%
n	51376	6.3%
a	48838	6.0%
M	48624	6.0%
r	48624	6.0%
Other values (4)	60772	7.4%

Common

Value	Count	Frequency (%)
	57592	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	874130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	148624	17.0%
o	106216	12.2%
g	97248	11.1%
t	90818	10.4%
H	57806	6.6%
m	57592	6.6%
	57592	6.6%
n	51376	5.9%
a	48838	5.6%
M	48624	5.6%
Other values (5)	109396	12.5%

Purpose
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	514
Missing (%)	0.5%
Memory size	785.4 KiB

Debt Consolidation	78552
other	6037
Home Improvements	5839
Other	3250
Business Loan	1569
Other values (11)	4753

Length

Max length	20
Median length	18
Mean length	16.32015
Min length	5

Characters and Unicode

Total characters	1632015
Distinct characters	35
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Home Improvements
2nd row	Debt Consolidation
3rd row	Debt Consolidation
4th row	Debt Consolidation
5th row	Debt Consolidation

Common Values

Value	Count	Frequency (%)
Debt Consolidation	78552	78.2%
other	6037	6.0%
Home Improvements	5839	5.8%
Other	3250	3.2%
Business Loan	1569	1.6%
Buy a Car	1265	1.3%
Medical Bills	1127	1.1%
Buy House	678	0.7%
Take a Trip	573	0.6%
major_purchase	352	0.4%
Other values (6)	758	0.8%
(Missing)	514	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt	78552	41.0%
consolidation	78552	41.0%
other	9287	4.8%
home	5839	3.0%
improvements	5839	3.0%
buy	1943	1.0%
a	1838	1.0%
business	1569	0.8%
loan	1569	0.8%
car	1265	0.7%
Other values (13)	5287	2.8%

Most occurring characters

Value	Count	Frequency (%)
o	256320	15.7%
t	172430	10.6%
n	166948	10.2%
i	162248	9.9%
e	110301	6.8%
s	92585	5.7%
	91540	5.6%
a	86321	5.3%
l	82608	5.1%
d	80008	4.9%
Other values (25)	330706	20.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1357176	83.2%
Uppercase Letter	182654	11.2%
Space Separator	91540	5.6%
Connector Punctuation	645	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	256320	18.9%
t	172430	12.7%
n	166948	12.3%
i	162248	12.0%
e	110301	8.1%
s	92585	6.8%
a	86321	6.4%
l	82608	6.1%
d	80008	5.9%
b	78845	5.8%
Other values (13)	68562	5.1%

Uppercase Letter

Value	Count	Frequency (%)
C	79817	43.7%
D	78552	43.0%
H	6517	3.6%
I	5839	3.2%
B	4639	2.5%
O	3250	1.8%
L	1569	0.9%
T	1146	0.6%
M	1127	0.6%
E	198	0.1%

Space Separator

Value	Count	Frequency (%)
	91540	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	645	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1539830	94.4%
Common	92185	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	256320	16.6%
t	172430	11.2%
n	166948	10.8%
i	162248	10.5%
e	110301	7.2%
s	92585	6.0%
a	86321	5.6%
l	82608	5.4%
d	80008	5.2%
C	79817	5.2%
Other values (23)	250244	16.3%

Common

Value	Count	Frequency (%)
	91540	99.3%
_	645	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1632015	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	256320	15.7%
t	172430	10.6%
n	166948	10.2%
i	162248	9.9%
e	110301	6.8%
s	92585	5.7%
	91540	5.6%
a	86321	5.3%
l	82608	5.1%
d	80008	4.9%
Other values (25)	330706	20.3%

Monthly Debt
Real number (ℝ)

Distinct	65765
Distinct (%)	65.8%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	18472.412

Minimum	0
Maximum	435843.28
Zeros	74
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	3714.823
Q1	10214.162
median	16220.3
Q3	24012.057
95-th percentile	40477.609
Maximum	435843.28
Range	435843.28
Interquartile range (IQR)	13797.895

Descriptive statistics

Standard deviation	12174.993
Coefficient of variation (CV)	0.65909056
Kurtosis	22.193058
Mean	18472.412
Median Absolute Deviation (MAD)	6724.48
Skewness	2.2139416
Sum	1.8472412 × 10⁹
Variance	1.4823045 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	74	0.1%
11162.88	9	< 0.1%
15903	9	< 0.1%
13033.43	8	< 0.1%
12967.5	8	< 0.1%
16279.2	8	< 0.1%
10647.98	8	< 0.1%
13359.85	8	< 0.1%
14726.52	8	< 0.1%
12656.47	8	< 0.1%
Other values (65755)	99852	99.3%
(Missing)	514	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.1%
7.41	2	< 0.1%
12.92	1	< 0.1%
17.1	1	< 0.1%
19.57	1	< 0.1%
20.71	1	< 0.1%
22.23	1	< 0.1%
28.5	1	< 0.1%
34.96	2	< 0.1%
41.99	1	< 0.1%

Value	Count	Frequency (%)
435843.28	1	< 0.1%
229057.92	1	< 0.1%
205801.35	1	< 0.1%
173265.56	2	< 0.1%
172156.15	1	< 0.1%
165810.53	1	< 0.1%
165437.18	2	< 0.1%
152512.24	1	< 0.1%
152331.93	1	< 0.1%
147152.53	1	< 0.1%

Years of Credit History
Real number (ℝ)

Distinct	506
Distinct (%)	0.5%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	18.199141

Minimum	3.6
Maximum	70.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	3.6
5-th percentile	9
Q1	13.5
median	16.9
Q3	21.7
95-th percentile	31.7
Maximum	70.5
Range	66.9
Interquartile range (IQR)	8.2

Descriptive statistics

Standard deviation	7.0153236
Coefficient of variation (CV)	0.38547554
Kurtosis	1.7407019
Mean	18.199141
Median Absolute Deviation (MAD)	4
Skewness	1.0715509
Sum	1819914.1
Variance	49.214766
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1340	1.3%
15	1305	1.3%
17	1219	1.2%
16.5	1176	1.2%
14	1151	1.1%
15.4	1065	1.1%
17.5	1025	1.0%
13	1021	1.0%
14.5	980	1.0%
18	967	1.0%
Other values (496)	88751	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.6	1	< 0.1%
3.7	2	< 0.1%
3.8	3	< 0.1%
3.9	4	< 0.1%
4	6	< 0.1%
4.1	8	< 0.1%
4.2	20	< 0.1%
4.3	9	< 0.1%
4.4	18	< 0.1%
4.5	17	< 0.1%

Value	Count	Frequency (%)
70.5	1	< 0.1%
65	2	< 0.1%
60.5	2	< 0.1%
59.9	1	< 0.1%
59.7	1	< 0.1%
59.5	2	< 0.1%
58	1	< 0.1%
57.7	2	< 0.1%
57.5	1	< 0.1%
57	1	< 0.1%

Months since last delinquent
Real number (ℝ)

Distinct	116
Distinct (%)	0.2%
Missing	53655
Missing (%)	53.4%
Infinite	0
Infinite (%)	0.0%
Mean	34.901321

Minimum	0
Maximum	176
Zeros	216
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	16
median	32
Q3	51
95-th percentile	75
Maximum	176
Range	176
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	21.997829
Coefficient of variation (CV)	0.63028642
Kurtosis	-0.74578961
Mean	34.901321
Median Absolute Deviation (MAD)	17
Skewness	0.43436156
Sum	1635441
Variance	483.90447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	922	0.9%
12	902	0.9%
14	877	0.9%
15	865	0.9%
10	861	0.9%
8	856	0.9%
9	849	0.8%
18	847	0.8%
16	837	0.8%
6	836	0.8%
Other values (106)	38207	38.0%
(Missing)	53655	53.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	216	0.2%
1	289	0.3%
2	418	0.4%
3	445	0.4%
4	513	0.5%
5	703	0.7%
6	836	0.8%
7	825	0.8%
8	856	0.9%
9	849	0.8%

Value	Count	Frequency (%)
176	2	< 0.1%
152	1	< 0.1%
148	1	< 0.1%
143	1	< 0.1%
141	1	< 0.1%
139	1	< 0.1%
131	1	< 0.1%
130	1	< 0.1%
129	1	< 0.1%
120	2	< 0.1%

Number of Open Accounts
Real number (ℝ)

Distinct	51
Distinct (%)	0.1%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	11.12853

Minimum	0
Maximum	76
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	10
Q3	14
95-th percentile	20
Maximum	76
Range	76
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.0098704
Coefficient of variation (CV)	0.45018258
Kurtosis	3.0427669
Mean	11.12853
Median Absolute Deviation (MAD)	3
Skewness	1.1792013
Sum	1112853
Variance	25.098801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	9360	9.3%
10	9012	9.0%
8	8792	8.7%
11	8601	8.6%
7	8090	8.0%
12	7461	7.4%
6	6731	6.7%
13	6280	6.2%
14	5194	5.2%
5	4742	4.7%
Other values (41)	25737	25.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	25	< 0.1%
2	448	0.4%
3	1364	1.4%
4	2849	2.8%
5	4742	4.7%
6	6731	6.7%
7	8090	8.0%
8	8792	8.7%
9	9360	9.3%

Value	Count	Frequency (%)
76	2	< 0.1%
56	2	< 0.1%
52	2	< 0.1%
48	4	< 0.1%
47	3	< 0.1%
45	6	< 0.1%
44	5	< 0.1%
43	10	< 0.1%
42	5	< 0.1%
41	7	< 0.1%

Number of Credit Problems
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	14
Distinct (%)	< 0.1%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.16831

Minimum	0
Maximum	15
Zeros	86035
Zeros (%)	85.6%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.48270496
Coefficient of variation (CV)	2.8679517
Kurtosis	48.012465
Mean	0.16831
Median Absolute Deviation (MAD)	0
Skewness	4.8231356
Sum	16831
Variance	0.23300407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	86035	85.6%
1	12077	12.0%
2	1299	1.3%
3	378	0.4%
4	125	0.1%
5	49	< 0.1%
6	17	< 0.1%
7	8	< 0.1%
8	4	< 0.1%
11	2	< 0.1%
Other values (4)	6	< 0.1%
(Missing)	514	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	86035	85.6%
1	12077	12.0%
2	1299	1.3%
3	378	0.4%
4	125	0.1%
5	49	< 0.1%
6	17	< 0.1%
7	8	< 0.1%
8	4	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	2	< 0.1%
9	2	< 0.1%
8	4	< 0.1%
7	8	< 0.1%
6	17	< 0.1%
5	49	< 0.1%
4	125	0.1%

Current Credit Balance
Real number (ℝ)

Distinct	32730
Distinct (%)	32.7%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	294637.38

Minimum	0
Maximum	32878968
Zeros	572
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	30400
Q1	112670
median	209817
Q3	367958.75
95-th percentile	760741
Maximum	32878968
Range	32878968
Interquartile range (IQR)	255288.75

Descriptive statistics

Standard deviation	376170.93
Coefficient of variation (CV)	1.2767251
Kurtosis	697.49819
Mean	294637.38
Median Absolute Deviation (MAD)	115007
Skewness	14.154428
Sum	2.9463738 × 10¹⁰
Variance	1.4150457 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	572	0.6%
67697	17	< 0.1%
65683	17	< 0.1%
175978	17	< 0.1%
124013	16	< 0.1%
246373	16	< 0.1%
88426	16	< 0.1%
100301	16	< 0.1%
148846	15	< 0.1%
118009	15	< 0.1%
Other values (32720)	99283	98.8%
(Missing)	514	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	572	0.6%
19	12	< 0.1%
38	9	< 0.1%
57	7	< 0.1%
76	4	< 0.1%
95	6	< 0.1%
114	7	< 0.1%
133	5	< 0.1%
152	2	< 0.1%
171	4	< 0.1%

Value	Count	Frequency (%)
32878968	1	< 0.1%
12986956	2	< 0.1%
12746397	2	< 0.1%
11796435	1	< 0.1%
11361924	1	< 0.1%
9134592	2	< 0.1%
7888952	1	< 0.1%
7749587	1	< 0.1%
7679344	1	< 0.1%
7666747	1	< 0.1%

Maximum Open Credit
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	44596
Distinct (%)	44.6%
Missing	516
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	760798.38

Minimum	0
Maximum	1.5397379 × 10⁹
Zeros	681
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	109758
Q1	273438
median	467874
Q3	782958
95-th percentile	1640226.5
Maximum	1.5397379 × 10⁹
Range	1.5397379 × 10⁹
Interquartile range (IQR)	509520

Descriptive statistics

Standard deviation	8384503.5
Coefficient of variation (CV)	11.020664
Kurtosis	20394.84
Mean	760798.38
Median Absolute Deviation (MAD)	230901
Skewness	132.63887
Sum	7.6078317 × 10¹⁰
Variance	7.0299898 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	681	0.7%
237204	13	< 0.1%
155474	12	< 0.1%
150194	12	< 0.1%
242968	12	< 0.1%
201652	12	< 0.1%
236412	12	< 0.1%
107404	12	< 0.1%
246136	12	< 0.1%
181456	11	< 0.1%
Other values (44586)	99209	98.7%
(Missing)	516	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	681	0.7%
4334	4	< 0.1%
4444	1	< 0.1%
5390	1	< 0.1%
6446	5	< 0.1%
6468	3	< 0.1%
6490	2	< 0.1%
6512	2	< 0.1%
6534	1	< 0.1%
6556	4	< 0.1%

Value	Count	Frequency (%)
1539737892	1	< 0.1%
1304726170	1	< 0.1%
980305260	1	< 0.1%
798255370	1	< 0.1%
632477736	1	< 0.1%
489343206	1	< 0.1%
380052288	1	< 0.1%
267490058	1	< 0.1%
265512874	1	< 0.1%
192284158	2	< 0.1%

Bankruptcies
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	718
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.11774019

Minimum	0
Maximum	7
Zeros	88774
Zeros (%)	88.3%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.35142382
Coefficient of variation (CV)	2.9847397
Kurtosis	18.527679
Mean	0.11774019
Median Absolute Deviation (MAD)	0
Skewness	3.5058037
Sum	11750
Variance	0.1234987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	88774	88.3%
1	10475	10.4%
2	417	0.4%
3	93	0.1%
4	27	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
(Missing)	718	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	88774	88.3%
1	10475	10.4%
2	417	0.4%
3	93	0.1%
4	27	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	2	< 0.1%
5	7	< 0.1%
4	27	< 0.1%
3	93	0.1%
2	417	0.4%
1	10475	10.4%
0	88774	88.3%

Tax Liens
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	524
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.029312931

Minimum	0
Maximum	15
Zeros	98062
Zeros (%)	97.6%
Negative	0
Negative (%)	0.0%
Memory size	785.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.25818244
Coefficient of variation (CV)	8.8078
Kurtosis	402.06666
Mean	0.029312931
Median Absolute Deviation (MAD)	0
Skewness	15.50022
Sum	2931
Variance	0.06665817
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	98062	97.6%
1	1343	1.3%
2	374	0.4%
3	111	0.1%
4	58	0.1%
5	16	< 0.1%
6	12	< 0.1%
7	7	< 0.1%
9	3	< 0.1%
11	2	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	524	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	98062	97.6%
1	1343	1.3%
2	374	0.4%
3	111	0.1%
4	58	0.1%
5	16	< 0.1%
6	12	< 0.1%
7	7	< 0.1%
9	3	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
11	2	< 0.1%
10	1	< 0.1%
9	3	< 0.1%
7	7	< 0.1%
6	12	< 0.1%
5	16	< 0.1%
4	58	0.1%
3	111	0.1%
2	374	0.4%

Auto

Heatmap
Table

	Current Loan Amount	Credit Score	Annual Income	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies	Tax Liens	Loan Status	Term	Years in current job	Home Ownership	Purpose
Current Loan Amount	1.000	-0.038	0.382	0.337	0.145	-0.023	0.176	-0.073	0.368	0.358	-0.079	0.013	0.195	0.061	0.000	0.009	0.020
Credit Score	-0.038	1.000	0.014	-0.077	0.082	0.040	-0.010	-0.067	-0.007	0.143	-0.051	-0.028	0.470	0.107	0.009	0.013	0.022
Annual Income	0.382	0.014	1.000	0.594	0.261	-0.087	0.242	-0.041	0.391	0.392	-0.059	0.041	0.004	0.000	0.000	0.004	0.000
Monthly Debt	0.337	-0.077	0.594	1.000	0.218	-0.058	0.461	-0.066	0.526	0.430	-0.077	0.021	0.008	0.050	0.014	0.055	0.000
Years of Credit History	0.145	0.082	0.261	0.218	1.000	-0.051	0.146	0.080	0.267	0.286	0.080	0.020	0.034	0.066	0.092	0.129	0.023
Months since last delinquent	-0.023	0.040	-0.087	-0.058	-0.051	1.000	-0.040	0.110	-0.004	-0.027	0.117	0.012	0.023	0.017	0.021	0.040	0.008
Number of Open Accounts	0.176	-0.010	0.242	0.461	0.146	-0.040	1.000	-0.008	0.374	0.490	-0.018	0.013	0.013	0.080	0.025	0.087	0.048
Number of Credit Problems	-0.073	-0.067	-0.041	-0.066	0.080	0.110	-0.008	1.000	-0.206	-0.173	0.868	0.368	0.000	0.014	0.007	0.010	0.013
Current Credit Balance	0.368	-0.007	0.391	0.526	0.267	-0.004	0.374	-0.206	1.000	0.778	-0.199	-0.032	0.012	0.012	0.004	0.020	0.000
Maximum Open Credit	0.358	0.143	0.392	0.430	0.286	-0.027	0.490	-0.173	0.778	1.000	-0.169	-0.023	0.000	0.005	0.004	0.040	0.013
Bankruptcies	-0.079	-0.051	-0.059	-0.077	0.080	0.117	-0.018	0.868	-0.199	-0.169	1.000	0.051	0.000	0.029	0.020	0.007	0.024
Tax Liens	0.013	-0.028	0.041	0.021	0.020	0.012	0.013	0.368	-0.032	-0.023	0.051	1.000	0.007	0.000	0.000	0.010	0.010
Loan Status	0.195	0.470	0.004	0.008	0.034	0.023	0.013	0.000	0.012	0.000	0.000	0.007	1.000	0.111	0.016	0.053	0.046
Term	0.061	0.107	0.000	0.050	0.066	0.017	0.080	0.014	0.012	0.005	0.029	0.000	0.111	1.000	0.070	0.120	0.074
Years in current job	0.000	0.009	0.000	0.014	0.092	0.021	0.025	0.007	0.004	0.004	0.020	0.000	0.016	0.070	1.000	0.123	0.029
Home Ownership	0.009	0.013	0.004	0.055	0.129	0.040	0.087	0.010	0.020	0.040	0.007	0.010	0.053	0.120	0.123	1.000	0.370
Purpose	0.020	0.022	0.000	0.000	0.023	0.008	0.048	0.013	0.000	0.013	0.024	0.010	0.046	0.074	0.029	0.370	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies
0	14dd8831-6af5-400b-83ec-68e61888a048	981165ec-3274-42f5-a3b4-d104041a9ca9	Fully Paid	445412.0	Short Term	709.0	1167493.0	8 years	Home Mortgage	Home Improvements	5214.74	17.2	NaN	6.0	1.0	228190.0	416746.0	1.0
1	4771cc26-131a-45db-b5aa-537ea4ba5342	2de017a3-2e01-49cb-a581-08169e83be29	Fully Paid	262328.0	Short Term	NaN	NaN	10+ years	Home Mortgage	Debt Consolidation	33295.98	21.1	8.0	35.0	0.0	229976.0	850784.0	0.0
2	4eed4e6a-aa2f-4c91-8651-ce984ee8fb26	5efb2b2b-bf11-4dfd-a572-3761a2694725	Fully Paid	99999999.0	Short Term	741.0	2231892.0	8 years	Own Home	Debt Consolidation	29200.53	14.9	29.0	18.0	1.0	297996.0	750090.0	0.0
3	77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a	e777faab-98ae-45af-9a86-7ce5b33b1011	Fully Paid	347666.0	Long Term	721.0	806949.0	3 years	Own Home	Debt Consolidation	8741.90	12.0	NaN	9.0	0.0	256329.0	386958.0	0.0
4	d4062e70-befa-4995-8643-a0de73938182	81536ad9-5ccf-4eb8-befb-47a4d608658e	Fully Paid	176220.0	Short Term	NaN	NaN	5 years	Rent	Debt Consolidation	20639.70	6.1	NaN	15.0	0.0	253460.0	427174.0	0.0
5	89d8cb0c-e5c2-4f54-b056-48a645c543dd	4ffe99d3-7f2a-44db-afc1-40943f1f9750	Charged Off	206602.0	Short Term	7290.0	896857.0	10+ years	Home Mortgage	Debt Consolidation	16367.74	17.3	NaN	6.0	0.0	215308.0	272448.0	0.0
6	273581de-85d8-4332-81a5-19b04ce68666	90a75dde-34d5-419c-90dc-1e58b04b3e35	Fully Paid	217646.0	Short Term	730.0	1184194.0	< 1 year	Home Mortgage	Debt Consolidation	10855.08	19.6	10.0	13.0	1.0	122170.0	272052.0	1.0
7	db0dc6e1-77ee-4826-acca-772f9039e1c7	018973c9-e316-4956-b363-67e134fb0931	Charged Off	648714.0	Long Term	NaN	NaN	< 1 year	Home Mortgage	Buy House	14806.13	8.2	8.0	15.0	0.0	193306.0	864204.0	0.0
8	8af915d9-9e91-44a0-b5a2-564a45c12089	af534dea-d27e-4fd6-9de8-efaa52a78ec0	Fully Paid	548746.0	Short Term	678.0	2559110.0	2 years	Rent	Debt Consolidation	18660.28	22.6	33.0	4.0	0.0	437171.0	555038.0	0.0
9	0b1c4e3d-bd97-45ce-9622-22732fcdc9a0	235c4a43-dadf-483d-aa44-9d6d77ae4583	Fully Paid	215952.0	Short Term	739.0	1454735.0	< 1 year	Rent	Debt Consolidation	39277.75	13.9	NaN	20.0	0.0	669560.0	1021460.0	0.0

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies	Tax Liens
100504	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100505	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100506	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100507	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100508	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100509	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100510	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100511	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100512	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
100513	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies	Tax Liens	# duplicates
10215	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	514
0	000bc65a-6a7c-4566-86f3-203b4ec35eca	724bddb4-a23c-4759-ba6f-dc79c7dd5334	Fully Paid	642202.0	Short Term	715.0	1759533.0	2 years	Rent	Debt Consolidation	23020.59	13.8	NaN	11.0	0.0	445987.0	733546.0	0.0	0.0	2
1	000c16df-c24f-41cf-a90e-60301d131bb9	b07c4262-70bb-41cc-b28a-d87540577fb1	Fully Paid	155496.0	Short Term	706.0	664753.0	NaN	Own Home	other	8087.92	21.3	NaN	7.0	1.0	79382.0	150700.0	1.0	0.0	2
2	0016d326-7878-46bb-9c18-a75af255d7fe	eccd2965-56cf-4be0-99b2-893f8a520fea	Fully Paid	88770.0	Short Term	700.0	1671221.0	2 years	Home Mortgage	Home Improvements	2562.53	10.3	NaN	3.0	1.0	67279.0	124234.0	1.0	0.0	2
3	0018f629-8cef-48bd-bb93-40179f24256c	1e96933c-3a01-46b2-975d-06c5a2b469c3	Fully Paid	66396.0	Short Term	711.0	535192.0	3 years	Rent	Debt Consolidation	9142.80	15.8	50.0	8.0	0.0	112347.0	307538.0	0.0	0.0	2
4	001a84a9-3fd5-4e82-9153-49325b996408	b282e6f9-2d09-4988-b579-6d90d104e70d	Fully Paid	180246.0	Long Term	658.0	858097.0	2 years	Rent	Other	10289.83	18.4	58.0	8.0	0.0	288553.0	440220.0	0.0	0.0	2
5	001f3ce7-5277-4202-8511-27b464ea6404	96875077-865f-4998-9e93-59b016165fdf	Fully Paid	65406.0	Short Term	705.0	1883090.0	3 years	Home Mortgage	Home Improvements	56021.88	23.4	NaN	11.0	0.0	408291.0	527648.0	0.0	0.0	2
6	002f3769-888e-4b66-b940-21ec4b7c2c69	f49f2a18-deba-45de-8af6-e0174b9b4894	Fully Paid	142824.0	Short Term	724.0	683183.0	4 years	Home Mortgage	Debt Consolidation	11272.51	15.4	NaN	7.0	0.0	27322.0	77000.0	0.0	0.0	2
7	003665f5-adff-4fbb-903c-14d022fa6a08	80c0ee25-ec87-4e1f-aefc-e5bbd679cef1	Fully Paid	43692.0	Short Term	719.0	679079.0	9 years	HaveMortgage	Take a Trip	8601.68	11.0	69.0	5.0	5.0	16264.0	174328.0	1.0	4.0	2
8	003d60c3-3a4c-4b81-b0f4-3105c34ce2e8	9d1e355e-f80d-40a8-b582-d391baa0dce9	Fully Paid	194370.0	Short Term	714.0	991952.0	10+ years	Home Mortgage	other	11242.11	21.0	32.0	6.0	0.0	168017.0	448272.0	0.0	0.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Math Symbol

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII